/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package db;

import java.sql.PreparedStatement;

/**
 *
 * @author Alexey Chirkov
 */
public class Service {
    public static String deleteRecordStudent="DELETE FROM stud WHERE num=?";
    public static String deleteRecordSession="DELETE FROM SESSIONSTUD WHERE num=? AND sessionnumber=? AND SUB1=? AND SUB2=? AND SUB3=?";
    public static String deleteRecordSessionStudent="DELETE FROM SESSIONSTUD WHERE NUM=?";
    
    public static String getInfoStudent="SELECT * FROM STUD";
    public static String getInfoSession="SELECT * FROM SESSIONSTUD";
    
    
    
}
